﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.ComponentModel.DataAnnotations.Schema;

namespace FingerPrint.WebUI.Models
{
    // Define the schema and table to connect
    [Table("Product", Schema = "Production")]
    public class Product
    {
        public int ProductID { get; set; }
        public string ProductNumber { get; set; }
        public string Description { get; set; }
        public int? ProductCategoryID { get; set; }
        public int? ProductGroupID { get; set; }

        // One-One relationship
        public virtual ProductGroup ProductGroup { get; set; }

        // One to Many relationship
        public virtual ICollection<SalesOrder> SaleOrders { get; set; }
    }
}
